sqlcmd.net validated sql reference

Tag archive

#foreign key

Commands grouped around the same concept, pattern, or recurring problem.

3 commands with this tag Browse related patterns quickly
intermediate ddl MySQL MariaDB SQL Server PostgreSQL SQLite

Add a Foreign Key Constraint

Enforce referential integrity by linking a column to the primary key of another table so orphaned rows cannot be inserted.

advanced deleting MySQL MariaDB SQL Server PostgreSQL SQLite

Delete Orphaned Child Rows

Remove child rows that reference missing parent rows before enforcing referential integrity.

intermediate data-quality MySQL MariaDB SQL Server PostgreSQL SQLite

Find Orphaned Child Rows

Find child rows whose foreign key value does not match any row in the parent table.